package com.jmgd.cjlx.dao;

import com.jmgd.cjlx.entity.*;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import java.util.Date;
import java.util.List;
import java.util.Map;

@Repository
@Mapper
public interface JmgdMapper {
    void insertInvoiceYk(String orderId,String kpDate);

    void insertWareTaxCode(String wareName,String taxCode);

    void updateWareTaxCode();

    void updateWarePrice();

    void insertLog(String dataType,String notes);

    void insertQywx(String userid,String externalUserid,String createDate);

    String selectBusname(String busno);

    List<MemcardEntity> selectMemcard();

    void insermemcardcheck(String memcardno,String checkreason);

    List<HbyHbportalprivEntity> selectHbportalpriv(String idNo,String allowExcel);

    List<HbyWareEntity> selectHbyWareList(String idNo);

    List<HbyQcQmStoreEntity> selectQcQmStore(String idNo,String period,String comDesc);

    List<HbyPurEntity> selectPur(String idNo,Date beginDate,Date endDate);

    List<HbyDistEntity> selectDist(String idNo,Date beginDate,Date endDate);

    List<HbySaleEntity> selectSale(String idNo,Date beginDate,Date endDate);

    List<HbyStoreAdjustEntity> selectStoreAjudst(String idNo,Date beginDate,Date endDate,String comDesc);

    List<Map<String,Object>> selectExcelSaleYJH(Date beginDate, Date endDate,String stockNo);

    List<Map<String,Object>> selectExcelSaleN50301YJH(Date beginDate, Date endDate,String stockNo);

    List<Map<String,Object>> selectExcelSaleYJD(String saleno,Date saleDate,String stockType);

    List<Map<String,Object>> selectExcelSaleYJD2(Date beginDate, Date endDate,String stockNo);

    List<Map<String,Object>> selectExcelSaleYJDN2(Date beginDate, Date endDate,String stockNo);
    //selectExcelSaleYJDN2


    List<Map<String,Object>> selectExcelReturnSaleYJH(Date beginDate, Date endDate,String stockNo);

    List<Map<String,Object>> selectExcelReturnSaleN50301YJH(Date beginDate, Date endDate,String stockNo);

    List<Map<String,Object>> selectExcelReturnSaleYJD(String saleno,Date saleDate,String stockType);

    List<Map<String,Object>> selectExcelReturnSaleYJD2(Date beginDate, Date endDate,String stockNo);

    List<Map<String,Object>> selectExcelReturnSaleYJDN2(Date beginDate, Date endDate,String stockNo);


    List<Map<String,Object>> selectExcelPurYJH(Date beginDate, Date endDate,String stockNo);

    List<Map<String,Object>> selectExcelPurN50301YJH(Date beginDate, Date endDate,String stockNo);

    List<Map<String,Object>> selectExcelPurYJD(String saleno,Date saleDate,String stockType);

    List<Map<String,Object>> selectExcelPurYJD2(Date beginDate, Date endDate,String stockNo);

    List<Map<String,Object>> selectExcelPurYJDN2(Date beginDate, Date endDate,String stockNo);

    List<Map<String,Object>> selectExcelReturnPurYJH(Date beginDate, Date endDate,String stockNo);

    List<Map<String,Object>> selectExcelReturnPurN50301YJH(Date beginDate, Date endDate,String stockNo);

    List<Map<String,Object>> selectExcelReturnPurYJD(String saleno,Date saleDate,String stockType);

    //selectExcelReturnPurYJD2   selectExcelReturnPurYJDN2
    List<Map<String,Object>> selectExcelReturnPurYJD2(Date beginDate, Date endDate,String stockNo);

    List<Map<String,Object>> selectExcelReturnPurYJDN2(Date beginDate, Date endDate,String stockNo);

    List<Map<String,Object>> selectStock(Date beginDate,String stockNo);

    List<Map<String,Object>> selectStockN50301(Date beginDate,String stockNo);

    List<Map<String,Object>> selectChoujiang(String lotteryid);
}
